<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>AmpleHarvest: cTABLE_Last_Indexed.php Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">AmpleHarvest
   &#160;<span id="projectnumber">0.0.1</span>
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.5.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="pages.html"><span>Related&#160;Pages</span></a></li>
      <li><a href="modules.html"><span>Modules</span></a></li>
      <li><a href="namespaces.html"><span>Namespaces</span></a></li>
      <li><a href="annotated.html"><span>Classes</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>File&#160;Members</span></a></li>
    </ul>
  </div>
</div>
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
  initNavTree('c_t_a_b_l_e___last___indexed_8php.html','');
</script>
<div id="doc-content">
<div class="header">
  <div class="headertitle">
<div class="title">cTABLE_Last_Indexed.php</div>  </div>
</div>
<div class="contents">
<a href="c_t_a_b_l_e___last___indexed_8php.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00005"></a>00005         use\ampleharvest\code;
<a name="l00006"></a>00006         require_once dirname(dirname(dirname(__FILE__))) . <span class="stringliteral">&#39;/config/cConfig.php&#39;</span>;
<a name="l00010"></a>00010         require_once code\cConfig::C_STR_DATABASE_LIB_PATH . <span class="stringliteral">&quot;/Classes/cTable.php&quot;</span>;
<a name="l00014"></a>00014         require_once code\cConfig::C_STR_DATABASE_LIB_PATH . <span class="stringliteral">&quot;/Classes/ColTypes.php&quot;</span>;
<a name="l00015"></a>00015 
<a name="l00029"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html">00029</a>         <span class="keyword">class </span><a class="code" href="classc_t_a_b_l_e___last___indexed.html" title="Includes the base class for Tables (uses base path from the cinfo file.">cTABLE_Last_Indexed</a> <span class="keyword">extends</span> cTable
<a name="l00030"></a>00030         {
<a name="l00035"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#ad077898da1668be20c85ec881a673c2e">00035</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#ad077898da1668be20c85ec881a673c2e">$m_int_COL_ID</a> = null;
<a name="l00036"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a0c42242a300d45bcd40aa0f6a6438705">00036</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a0c42242a300d45bcd40aa0f6a6438705">$m_int_COL_Revision</a> = null;
<a name="l00037"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a6a892a1b8826e85cc270f62345688cbb">00037</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a6a892a1b8826e85cc270f62345688cbb">$m_int_COL_Date</a> = null;
<a name="l00038"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a23281ba5f596fe2a4ab8aa2710431706">00038</a>                 <span class="keyword">public</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a23281ba5f596fe2a4ab8aa2710431706">$m_int_COL_Status</a> = null;
<a name="l00051"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#ac490efb1b4cba1b4fdcb905f4ea0d442">00051</a>                 <span class="keyword">const</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#ac490efb1b4cba1b4fdcb905f4ea0d442" title="This Option shows that the entry has had no processing done to it.">C_INT_STATUS_NEW</a> = 0;
<a name="l00056"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#ab4d2248f393452569112281e8b881b78">00056</a>                 <span class="keyword">const</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#ab4d2248f393452569112281e8b881b78" title="This Option shows that the entry is currently being processed.">C_INT_STATUS_PROCESSING</a> = 1;
<a name="l00061"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#aa4259df7c5f422eb5ae4a068a5314ed9">00061</a>                 <span class="keyword">const</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#aa4259df7c5f422eb5ae4a068a5314ed9" title="This Option shows that the entry has been successfuly processed.">C_INT_STATUS_SUCCESS</a> = 2;
<a name="l00066"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a839d59f1d3f020d4845af522c6a3e7bd">00066</a>                 <span class="keyword">const</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a839d59f1d3f020d4845af522c6a3e7bd" title="This Option shows that the entry has had an error while processing.">C_INT_STATUS_ERROR</a> = 3;
<a name="l00067"></a>00067 
<a name="l00075"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a095c5d389db211932136b53f25f39685">00075</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a095c5d389db211932136b53f25f39685" title="This constructor sets all the required column data.">__construct</a>()
<a name="l00076"></a>00076                 {
<a name="l00077"></a>00077                         $this-&gt;m_str_TableName = <span class="stringliteral">&quot;last_indexed&quot;</span>;
<a name="l00078"></a>00078                         $this-&gt;set_Engine(self::C_STR_ENGINE_INNODB);
<a name="l00079"></a>00079 
<a name="l00080"></a>00080                         <span class="comment">//Create Column Objects</span>
<a name="l00081"></a>00081                         $obj_COL_ID = <span class="keyword">new</span> cColInt(<span class="stringliteral">&quot;id&quot;</span>);
<a name="l00082"></a>00082                         $obj_COL_ID-&gt;set_Length(10);
<a name="l00083"></a>00083                         $obj_COL_ID-&gt;set_Index(abs_Column::c_int_INDEX_PRIMARY);
<a name="l00084"></a>00084                         $obj_COL_ID-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the ID of the page that was indexed.&quot;</span>);
<a name="l00085"></a>00085                         $obj_COL_ID-&gt;set_Editable(<span class="keyword">false</span>);
<a name="l00086"></a>00086                         $obj_COL_ID-&gt;set_Label(<span class="stringliteral">&quot;ID&quot;</span>);
<a name="l00087"></a>00087 
<a name="l00088"></a>00088                         $obj_COL_Revision = <span class="keyword">new</span> cColInt(<span class="stringliteral">&quot;revision&quot;</span>);
<a name="l00089"></a>00089                         $obj_COL_Revision-&gt;set_Length(10);
<a name="l00090"></a>00090                         $obj_COL_Revision-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the revision that was indexed.&quot;</span>);
<a name="l00091"></a>00091                         $obj_COL_Revision-&gt;set_Label(<span class="stringliteral">&quot;Revision&quot;</span>);
<a name="l00092"></a>00092 
<a name="l00093"></a>00093                         $obj_COL_Date = <span class="keyword">new</span> cColTimeStamp(<span class="stringliteral">&quot;date&quot;</span>);
<a name="l00094"></a>00094                         $obj_COL_Date-&gt;set_Null(<span class="keyword">false</span>);
<a name="l00095"></a>00095                         <span class="comment">//$obj_COL_Date-&gt;set_Default(&quot;CURRENT_TIMESTAMP&quot;);</span>
<a name="l00096"></a>00096                         $obj_COL_Date-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the Date that the column was last touched.&quot;</span>);
<a name="l00097"></a>00097                         $obj_COL_Date-&gt;set_Label(<span class="stringliteral">&quot;Time Stamp&quot;</span>);
<a name="l00098"></a>00098 
<a name="l00099"></a>00099                         $obj_COL_Status = <span class="keyword">new</span> cColSmallInt(<span class="stringliteral">&quot;status&quot;</span>);
<a name="l00100"></a>00100                         $obj_COL_Status-&gt;set_Null(<span class="keyword">true</span>);
<a name="l00101"></a>00101                         $obj_COL_Date-&gt;set_Default(<span class="stringliteral">&quot;0&quot;</span>);
<a name="l00102"></a>00102                         $obj_COL_Status-&gt;set_Comment(<span class="stringliteral">&quot;This column holds the Status of a given entry.&quot;</span>);
<a name="l00103"></a>00103                         $obj_COL_Status-&gt;set_Label(<span class="stringliteral">&quot;Status&quot;</span>);
<a name="l00104"></a>00104 
<a name="l00105"></a>00105                         <span class="comment">//Set up connection</span>
<a name="l00106"></a>00106                         $this-&gt;m_obj_Connection = <span class="keyword">new</span> cConnection(<span class="stringliteral">&quot;AmpleHarvest&quot;</span>, <span class="stringliteral">&quot;admin&quot;</span>);
<a name="l00107"></a>00107 
<a name="l00108"></a>00108                         <span class="comment">//Activate all Debug options</span>
<a name="l00109"></a>00109                         $this-&gt;m_obj_Connection-&gt;set_DebugLevel(cLog_Connection_Debug::c_int_LEVEL_BASIC);
<a name="l00110"></a>00110                         $this-&gt;m_obj_Connection-&gt;set_LogLevel(cLog_Connection::c_int_LEVEL_BASIC);
<a name="l00111"></a>00111                         <span class="comment">//                      $this-&gt;m_obj_Connection-&gt;activate_Logging();</span>
<a name="l00112"></a>00112                         <span class="comment">//                      $this-&gt;m_obj_Connection-&gt;activate_LogDebug();</span>
<a name="l00113"></a>00113                         <span class="comment">//$this-&gt;m_obj_Connection-&gt;activate_ScreenDebug();</span>
<a name="l00114"></a>00114 
<a name="l00115"></a>00115                         $this-&gt;m_int_COL_ID = $this-&gt;add_Column($obj_COL_ID);
<a name="l00116"></a>00116                         $this-&gt;m_int_COL_Revision = $this-&gt;add_Column($obj_COL_Revision);
<a name="l00117"></a>00117                         $this-&gt;m_int_COL_Date = $this-&gt;add_Column($obj_COL_Date);
<a name="l00118"></a>00118                         $this-&gt;m_int_COL_Status = $this-&gt;add_Column($obj_COL_Status);
<a name="l00119"></a>00119                 }
<a name="l00120"></a>00120 
<a name="l00126"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#aaa0511138910602ab53cca9d0ec084e4">00126</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#aaa0511138910602ab53cca9d0ec084e4" title="Returns if the id is a valid and existing ID.">validate_ID</a>($int_ID)
<a name="l00127"></a>00127                 {
<a name="l00128"></a>00128                         <span class="comment">// ensure that there is an ID passed and that it is a valid GUID</span>
<a name="l00129"></a>00129                         <span class="keywordflow">if</span> (!empty($int_ID) &amp;&amp; is_numeric($int_ID))
<a name="l00130"></a>00130                         {
<a name="l00131"></a>00131                                 $this-&gt;clear_Query();
<a name="l00132"></a>00132                                 $this-&gt;add_ColumnQuery($this-&gt;m_int_COL_ID, $int_ID);
<a name="l00133"></a>00133                                 <span class="keywordflow">if</span> ($this-&gt;do_Search() &gt; 0)
<a name="l00134"></a>00134                                 {
<a name="l00135"></a>00135                                         <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00136"></a>00136                                 }
<a name="l00137"></a>00137                         }
<a name="l00138"></a>00138                         <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00139"></a>00139                 }
<a name="l00145"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a7f7d36d28f818d0d64ae30da6f170a0a">00145</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a7f7d36d28f818d0d64ae30da6f170a0a" title="Loads information into object from Database based on ID passed.">load_DataFromID</a>(<a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>)
<a name="l00146"></a>00146                 {
<a name="l00147"></a>00147                         $this-&gt;clear();
<a name="l00148"></a>00148 
<a name="l00149"></a>00149                         <span class="keywordflow">if</span> ($this-&gt;<a class="code" href="classc_t_a_b_l_e___last___indexed.html#aaa0511138910602ab53cca9d0ec084e4" title="Returns if the id is a valid and existing ID.">validate_ID</a>(<a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>))
<a name="l00150"></a>00150                         {
<a name="l00151"></a>00151                                 $this-&gt;clear_Query();
<a name="l00152"></a>00152                                 $this-&gt;add_ColumnQuery($this-&gt;m_int_COL_ID, <a class="code" href="task__runner_8php.html#a638f33f9a90952d7cebdf44588e8f40b">$str_ID</a>);
<a name="l00153"></a>00153                                 <span class="keywordflow">if</span> ($this-&gt;do_Search() &gt; 0)
<a name="l00154"></a>00154                                 {
<a name="l00155"></a>00155                                         $obj_RS = $this-&gt;get_ResultSet();
<a name="l00156"></a>00156                                         <span class="keywordflow">if</span> ($obj_RS[0])
<a name="l00157"></a>00157                                         {
<a name="l00158"></a>00158                                                 $this-&gt;load_DataFromArray($obj_RS[0]);
<a name="l00159"></a>00159                                                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00160"></a>00160                                         }
<a name="l00161"></a>00161                                 }
<a name="l00162"></a>00162                         }
<a name="l00163"></a>00163                         <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00164"></a>00164                 }
<a name="l00165"></a>00165 
<a name="l00169"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a42e7dcfc7851c0dedcafb63968ffbc02">00169</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a42e7dcfc7851c0dedcafb63968ffbc02" title="Saves Information to the Database.">save_Data2DB</a>()
<a name="l00170"></a>00170                 {
<a name="l00171"></a>00171                         <span class="comment">//                      $this-&gt;output_Debug_Object_HTML();</span>
<a name="l00172"></a>00172                         <span class="keywordflow">if</span> ($this-&gt;<a class="code" href="classc_t_a_b_l_e___last___indexed.html#aaa0511138910602ab53cca9d0ec084e4" title="Returns if the id is a valid and existing ID.">validate_ID</a>($this-&gt;get_id()))
<a name="l00173"></a>00173                         {
<a name="l00174"></a>00174                                 <span class="keywordflow">return</span> $this-&gt;<a class="code" href="classc_t_a_b_l_e___last___indexed.html#a8bf8fc7182a41039d94dd975a0b40229" title="This function is used to update data that is already in the database.">update_Data2DB</a>();
<a name="l00175"></a>00175                         }
<a name="l00176"></a>00176                         <span class="keywordflow">else</span>
<a name="l00177"></a>00177                         {
<a name="l00178"></a>00178                                 <span class="keywordflow">return</span> $this-&gt;<a class="code" href="classc_t_a_b_l_e___last___indexed.html#a2055504e90b0a396c1de85aaad0c80ab" title="This function is used to insert Data into the database.">insert_Data2DB</a>();
<a name="l00179"></a>00179                         }
<a name="l00180"></a>00180 
<a name="l00181"></a>00181                         <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00182"></a>00182                 }
<a name="l00186"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a8bf8fc7182a41039d94dd975a0b40229">00186</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a8bf8fc7182a41039d94dd975a0b40229" title="This function is used to update data that is already in the database.">update_Data2DB</a>()
<a name="l00187"></a>00187                 {
<a name="l00188"></a>00188                         $this-&gt;clear_Update();
<a name="l00189"></a>00189                         $this-&gt;add_ColumnQuery($this-&gt;m_int_COL_ID, $this-&gt;get_id());
<a name="l00190"></a>00190 
<a name="l00191"></a>00191                         <span class="keywordflow">return</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a8bf8fc7182a41039d94dd975a0b40229" title="This function is used to update data that is already in the database.">parent::update_Data2DB</a>();
<a name="l00192"></a>00192                 }
<a name="l00196"></a><a class="code" href="classc_t_a_b_l_e___last___indexed.html#a2055504e90b0a396c1de85aaad0c80ab">00196</a>                 <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a2055504e90b0a396c1de85aaad0c80ab" title="This function is used to insert Data into the database.">insert_Data2DB</a>()
<a name="l00197"></a>00197                 {
<a name="l00198"></a>00198                         <span class="keywordflow">return</span> <a class="code" href="classc_t_a_b_l_e___last___indexed.html#a2055504e90b0a396c1de85aaad0c80ab" title="This function is used to insert Data into the database.">parent::insert_Data2DB</a>();
<a name="l00199"></a>00199                 }
<a name="l00200"></a>00200         }
<a name="l00201"></a>00201 ?&gt;
</pre></div></div>
</div>
  <div id="nav-path" class="navpath">
    <ul>
      <li class="navelem"><a class="el" href="c_t_a_b_l_e___last___indexed_8php.html">cTABLE_Last_Indexed.php</a>      </li>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>


    <li class="footer">Generated on Mon Jan 23 2012 13:34:20 for AmpleHarvest by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.5.1 </li>
   </ul>
 </div>


</body>
</html>
